Pandas Profiling Report

Dataset statistics

Number of variables	13
Number of observations	167693
Missing cells	480
Missing cells (%)	< 0.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	16.6 MiB
Average record size in memory	104.0 B

Variable types

Numeric	12
Categorical	1

Warnings

`ignore` has constant value "0"	Constant
`open time` is highly correlated with `open` and 4 other fields	High correlation
`open` is highly correlated with `open time` and 4 other fields	High correlation
`high` is highly correlated with `open time` and 4 other fields	High correlation
`low` is highly correlated with `open time` and 4 other fields	High correlation
`close` is highly correlated with `open time` and 4 other fields	High correlation
`volume` is highly correlated with `quote_asset_volume` and 3 other fields	High correlation
`close_time` is highly correlated with `open time` and 4 other fields	High correlation
`quote_asset_volume` is highly correlated with `volume` and 3 other fields	High correlation
`number_of_trades` is highly correlated with `volume` and 3 other fields	High correlation
`taker_buy_base_asset_volume` is highly correlated with `volume` and 3 other fields	High correlation
`taker_buy_quote_asset_volume` is highly correlated with `volume` and 3 other fields	High correlation
`open time` is highly correlated with `open` and 4 other fields	High correlation
`open` is highly correlated with `open time` and 4 other fields	High correlation
`high` is highly correlated with `open time` and 4 other fields	High correlation
`low` is highly correlated with `open time` and 4 other fields	High correlation
`close` is highly correlated with `open time` and 4 other fields	High correlation
`volume` is highly correlated with `quote_asset_volume` and 3 other fields	High correlation
`close_time` is highly correlated with `open time` and 4 other fields	High correlation
`quote_asset_volume` is highly correlated with `volume` and 3 other fields	High correlation
`number_of_trades` is highly correlated with `volume` and 3 other fields	High correlation
`taker_buy_base_asset_volume` is highly correlated with `volume` and 3 other fields	High correlation
`taker_buy_quote_asset_volume` is highly correlated with `volume` and 3 other fields	High correlation
`open time` is highly correlated with `close_time`	High correlation
`open` is highly correlated with `high` and 2 other fields	High correlation
`high` is highly correlated with `open` and 2 other fields	High correlation
`low` is highly correlated with `open` and 2 other fields	High correlation
`close` is highly correlated with `open` and 2 other fields	High correlation
`volume` is highly correlated with `quote_asset_volume` and 3 other fields	High correlation
`close_time` is highly correlated with `open time`	High correlation
`quote_asset_volume` is highly correlated with `volume` and 3 other fields	High correlation
`number_of_trades` is highly correlated with `volume` and 3 other fields	High correlation
`taker_buy_base_asset_volume` is highly correlated with `volume` and 3 other fields	High correlation
`taker_buy_quote_asset_volume` is highly correlated with `volume` and 3 other fields	High correlation
`low` is highly correlated with `open time` and 4 other fields	High correlation
`open time` is highly correlated with `low` and 4 other fields	High correlation
`close_time` is highly correlated with `low` and 4 other fields	High correlation
`number_of_trades` is highly correlated with `volume` and 3 other fields	High correlation
`volume` is highly correlated with `number_of_trades` and 3 other fields	High correlation
`taker_buy_quote_asset_volume` is highly correlated with `number_of_trades` and 3 other fields	High correlation
`high` is highly correlated with `low` and 4 other fields	High correlation
`taker_buy_base_asset_volume` is highly correlated with `number_of_trades` and 3 other fields	High correlation
`open` is highly correlated with `low` and 4 other fields	High correlation
`quote_asset_volume` is highly correlated with `number_of_trades` and 3 other fields	High correlation
`close` is highly correlated with `low` and 4 other fields	High correlation
`volume` is highly skewed (γ1 = 20.69985771)	Skewed
`taker_buy_base_asset_volume` is highly skewed (γ1 = 27.29847463)	Skewed
`taker_buy_quote_asset_volume` is highly skewed (γ1 = 22.69475006)	Skewed
`open time` is uniformly distributed	Uniform
`close_time` is uniformly distributed	Uniform
`open time` has unique values	Unique
`close_time` has unique values	Unique
`volume` has 33414 (19.9%) zeros	Zeros
`quote_asset_volume` has 33414 (19.9%) zeros	Zeros
`number_of_trades` has 33414 (19.9%) zeros	Zeros
`taker_buy_base_asset_volume` has 70012 (41.8%) zeros	Zeros
`taker_buy_quote_asset_volume` has 70012 (41.8%) zeros	Zeros

Reproduction

Analysis started	2022-02-14 19:16:12.398787
Analysis finished	2022-02-14 19:16:56.090242
Duration	43.69 seconds
Software version	pandas-profiling v3.0.0
Download configuration	config.json

open time
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
UNIFORM
UNIQUE

Distinct	167693
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.629688153 × 10¹²

Minimum	1.6145568 × 10¹²
Maximum	1.64479662 × 10¹²
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	1.6145568 × 10¹²
5-th percentile	1.616071428 × 10¹²
Q1	1.62213426 × 10¹²
median	1.62969714 × 10¹²
Q3	1.63725048 × 10¹²
95-th percentile	1.643287392 × 10¹²
Maximum	1.64479662 × 10¹²
Range	3.023982 × 10¹⁰
Interquartile range (IQR)	1.511622 × 10¹⁰

Descriptive statistics

Standard deviation	8729706727
Coefficient of variation (CV)	0.005356673121
Kurtosis	-1.20006685
Mean	1.629688153 × 10¹²
Median Absolute Deviation (MAD)	7558200000
Skewness	-0.001590850162
Sum	2.732872955 × 10¹⁷
Variance	7.620777954 × 10¹⁹
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.62151722 × 10¹²	1	< 0.1%
1.61873136 × 10¹²	1	< 0.1%
1.63716822 × 10¹²	1	< 0.1%
1.6215939 × 10¹²	1	< 0.1%
1.64401092 × 10¹²	1	< 0.1%
1.64064096 × 10¹²	1	< 0.1%
1.6293582 × 10¹²	1	< 0.1%
1.6182468 × 10¹²	1	< 0.1%
1.63817586 × 10¹²	1	< 0.1%
1.62048186 × 10¹²	1	< 0.1%
Other values (167683)	167683	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1.6145568 × 10¹²	1	< 0.1%
1.61455698 × 10¹²	1	< 0.1%
1.61455716 × 10¹²	1	< 0.1%
1.61455734 × 10¹²	1	< 0.1%
1.61455752 × 10¹²	1	< 0.1%
1.6145577 × 10¹²	1	< 0.1%
1.61455788 × 10¹²	1	< 0.1%
1.61455806 × 10¹²	1	< 0.1%
1.61455824 × 10¹²	1	< 0.1%
1.61455842 × 10¹²	1	< 0.1%

Value	Count	Frequency (%)
1.64479662 × 10¹²	1	< 0.1%
1.64479644 × 10¹²	1	< 0.1%
1.64479626 × 10¹²	1	< 0.1%
1.64479608 × 10¹²	1	< 0.1%
1.6447959 × 10¹²	1	< 0.1%
1.64479572 × 10¹²	1	< 0.1%
1.64479554 × 10¹²	1	< 0.1%
1.64479536 × 10¹²	1	< 0.1%
1.64479518 × 10¹²	1	< 0.1%
1.644795 × 10¹²	1	< 0.1%

open
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	109864
Distinct (%)	65.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3031.148652

Minimum	1415.01
Maximum	4861.97
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	1415.01
5-th percentile	1771.492
Q1	2290.52
median	3062.54
Q3	3788.48
95-th percentile	4443.128
Maximum	4861.97
Range	3446.96
Interquartile range (IQR)	1497.96

Descriptive statistics

Standard deviation	861.7681297
Coefficient of variation (CV)	0.2843041462
Kurtosis	-1.083984556
Mean	3031.148652
Median Absolute Deviation (MAD)	746.59
Skewness	0.129313889
Sum	508302410.9
Variance	742644.3093
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3340.5	59	< 0.1%
3123.84	52	< 0.1%
3224.79	51	< 0.1%
3262.7	40	< 0.1%
2923.7	37	< 0.1%
3182.15	32	< 0.1%
3300	32	< 0.1%
3006.59	28	< 0.1%
2596.44	28	< 0.1%
3067.63	27	< 0.1%
Other values (109854)	167307	99.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1415.01	1	< 0.1%
1416.68	1	< 0.1%
1418.62	1	< 0.1%
1420.64	1	< 0.1%
1422.22	1	< 0.1%
1424.1	1	< 0.1%
1424.55	1	< 0.1%
1424.7	1	< 0.1%
1425.14	1	< 0.1%
1425.62	1	< 0.1%

Value	Count	Frequency (%)
4861.97	2	< 0.1%
4860.45	1	< 0.1%
4855.18	1	< 0.1%
4853.49	1	< 0.1%
4853.17	1	< 0.1%
4851.02	1	< 0.1%
4850.85	1	< 0.1%
4850.14	1	< 0.1%
4850	1	< 0.1%
4849.8	1	< 0.1%

high
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	106082
Distinct (%)	63.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3033.034522

Minimum	1415.01
Maximum	4864.53
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	1415.01
5-th percentile	1772.336
Q1	2293.05
median	3064.28
Q3	3789.95
95-th percentile	4444.18
Maximum	4864.53
Range	3449.52
Interquartile range (IQR)	1496.9

Descriptive statistics

Standard deviation	861.8730925
Coefficient of variation (CV)	0.2841619791
Kurtosis	-1.08339271
Mean	3033.034522
Median Absolute Deviation (MAD)	746.28
Skewness	0.1285407293
Sum	508618658.2
Variance	742825.2276
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3340.5	59	< 0.1%
3123.84	52	< 0.1%
3224.79	51	< 0.1%
3262.7	39	< 0.1%
3300	38	< 0.1%
2923.7	36	< 0.1%
3182.15	32	< 0.1%
2140	31	< 0.1%
2668.94	31	< 0.1%
2456.96	29	< 0.1%
Other values (106072)	167295	99.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1415.01	1	< 0.1%
1416.68	1	< 0.1%
1418.62	1	< 0.1%
1420.64	1	< 0.1%
1424.55	1	< 0.1%
1424.7	1	< 0.1%
1425.62	1	< 0.1%
1426.57	1	< 0.1%
1426.64	1	< 0.1%
1427.19	1	< 0.1%

Value	Count	Frequency (%)
4864.53	1	< 0.1%
4863.25	1	< 0.1%
4861.97	1	< 0.1%
4860.45	1	< 0.1%
4860	1	< 0.1%
4859.4	1	< 0.1%
4857.42	1	< 0.1%
4856.83	1	< 0.1%
4853.91	1	< 0.1%
4853.49	1	< 0.1%

low
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	106512
Distinct (%)	63.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3028.993787

Minimum	1320
Maximum	4858.83
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	1320
5-th percentile	1770.57
Q1	2287.97
median	3060.74
Q3	3786.12
95-th percentile	4441.18
Maximum	4858.83
Range	3538.83
Interquartile range (IQR)	1498.15

Descriptive statistics

Standard deviation	861.591016
Coefficient of variation (CV)	0.284447931
Kurtosis	-1.08446744
Mean	3028.993787
Median Absolute Deviation (MAD)	747.08
Skewness	0.1300496673
Sum	507941055.2
Variance	742339.0788
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3340.5	59	< 0.1%
3123.84	52	< 0.1%
3224.79	52	< 0.1%
3262.7	41	< 0.1%
2923.7	36	< 0.1%
2596.44	32	< 0.1%
3182.15	32	< 0.1%
2568.73	31	< 0.1%
3006.59	29	< 0.1%
3300	28	< 0.1%
Other values (106502)	167301	99.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1320	1	< 0.1%
1413.51	1	< 0.1%
1413.88	1	< 0.1%
1416.68	1	< 0.1%
1418.62	1	< 0.1%
1422.22	1	< 0.1%
1423.63	1	< 0.1%
1423.86	1	< 0.1%
1424.55	1	< 0.1%
1424.7	1	< 0.1%

Value	Count	Frequency (%)
4858.83	1	< 0.1%
4853.9	1	< 0.1%
4851.02	1	< 0.1%
4849.05	1	< 0.1%
4848.97	1	< 0.1%
4848.39	1	< 0.1%
4848.38	1	< 0.1%
4847.85	1	< 0.1%
4847.84	1	< 0.1%
4846.67	1	< 0.1%

close
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	102300
Distinct (%)	61.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3031.053097

Minimum	1413.51
Maximum	4858.83
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	1413.51
5-th percentile	1771.33
Q1	2290.43
median	3062.43
Q3	3788.18
95-th percentile	4442.644
Maximum	4858.83
Range	3445.32
Interquartile range (IQR)	1497.75

Descriptive statistics

Standard deviation	861.7340972
Coefficient of variation (CV)	0.2843018811
Kurtosis	-1.083983989
Mean	3031.053097
Median Absolute Deviation (MAD)	746.68
Skewness	0.1292738289
Sum	508286387
Variance	742585.6543
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3340.5	60	< 0.1%
3224.79	52	< 0.1%
3123.84	52	< 0.1%
3262.7	40	< 0.1%
3300	38	< 0.1%
2923.7	36	< 0.1%
3182.15	32	< 0.1%
2596.44	29	< 0.1%
2568.73	28	< 0.1%
2668.94	28	< 0.1%
Other values (102290)	167298	99.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1413.51	1	< 0.1%
1413.88	1	< 0.1%
1416.68	1	< 0.1%
1418.62	1	< 0.1%
1423.33	1	< 0.1%
1424.55	1	< 0.1%
1424.7	1	< 0.1%
1424.74	1	< 0.1%
1424.94	1	< 0.1%
1424.95	1	< 0.1%

Value	Count	Frequency (%)
4858.83	1	< 0.1%
4855.67	1	< 0.1%
4853.9	1	< 0.1%
4852.83	1	< 0.1%
4851.12	1	< 0.1%
4851.02	2	< 0.1%
4850.91	1	< 0.1%
4850.87	1	< 0.1%
4850.41	1	< 0.1%
4850.19	1	< 0.1%

volume
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED
ZEROS

Distinct	98498
Distinct (%)	58.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.197698078

Minimum	0
Maximum	739.03261
Zeros	33414
Zeros (%)	19.9%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.0249
median	1.03538
Q3	3.4964
95-th percentile	12.593764
Maximum	739.03261
Range	739.03261
Interquartile range (IQR)	3.4715

Descriptive statistics

Standard deviation	8.05923681
Coefficient of variation (CV)	2.5203245
Kurtosis	1087.809066
Mean	3.197698078
Median Absolute Deviation (MAD)	1.03538
Skewness	20.69985771
Sum	536231.5837
Variance	64.95129796
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	33414	19.9%
1	331	0.2%
0.5	254	0.2%
0.4	219	0.1%
0.6	203	0.1%
0.2	191	0.1%
0.05	189	0.1%
0.0139	182	0.1%
0.1	175	0.1%
0.7	171	0.1%
Other values (98488)	132364	78.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	33414	19.9%
1 × 10^-5	4	< 0.1%
2 × 10^-5	2	< 0.1%
3 × 10^-5	1	< 0.1%
4 × 10^-5	1	< 0.1%
5 × 10^-5	1	< 0.1%
6 × 10^-5	2	< 0.1%
8 × 10^-5	1	< 0.1%
9 × 10^-5	1	< 0.1%
0.0001	11	< 0.1%

Value	Count	Frequency (%)
739.03261	1	< 0.1%
629.92252	1	< 0.1%
503.49054	1	< 0.1%
480.44094	1	< 0.1%
468.68257	1	< 0.1%
415.49919	1	< 0.1%
398.49465	1	< 0.1%
322.6957	1	< 0.1%
279.807	1	< 0.1%
273.81611	1	< 0.1%

close_time
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
UNIFORM
UNIQUE

Distinct	167693
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.629688333 × 10¹²

Minimum	1.61455698 × 10¹²
Maximum	1.6447968 × 10¹²
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	1.61455698 × 10¹²
5-th percentile	1.616071608 × 10¹²
Q1	1.62213444 × 10¹²
median	1.62969732 × 10¹²
Q3	1.63725066 × 10¹²
95-th percentile	1.643287572 × 10¹²
Maximum	1.6447968 × 10¹²
Range	3.023982 × 10¹⁰
Interquartile range (IQR)	1.511622 × 10¹⁰

Descriptive statistics

Standard deviation	8729706728
Coefficient of variation (CV)	0.00535667253
Kurtosis	-1.20006685
Mean	1.629688333 × 10¹²
Median Absolute Deviation (MAD)	7558200000
Skewness	-0.001590850265
Sum	2.732873257 × 10¹⁷
Variance	7.620777956 × 10¹⁹
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.63081134 × 10¹²	1	< 0.1%
1.64172888 × 10¹²	1	< 0.1%
1.63538226 × 10¹²	1	< 0.1%
1.64293974 × 10¹²	1	< 0.1%
1.62189612 × 10¹²	1	< 0.1%
1.62848592 × 10¹²	1	< 0.1%
1.63570788 × 10¹²	1	< 0.1%
1.61889822 × 10¹²	1	< 0.1%
1.63106298 × 10¹²	1	< 0.1%
1.61668944 × 10¹²	1	< 0.1%
Other values (167683)	167683	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1.61455698 × 10¹²	1	< 0.1%
1.61455716 × 10¹²	1	< 0.1%
1.61455734 × 10¹²	1	< 0.1%
1.61455752 × 10¹²	1	< 0.1%
1.6145577 × 10¹²	1	< 0.1%
1.61455788 × 10¹²	1	< 0.1%
1.61455806 × 10¹²	1	< 0.1%
1.61455824 × 10¹²	1	< 0.1%
1.61455842 × 10¹²	1	< 0.1%
1.6145586 × 10¹²	1	< 0.1%

Value	Count	Frequency (%)
1.6447968 × 10¹²	1	< 0.1%
1.64479662 × 10¹²	1	< 0.1%
1.64479644 × 10¹²	1	< 0.1%
1.64479626 × 10¹²	1	< 0.1%
1.64479608 × 10¹²	1	< 0.1%
1.6447959 × 10¹²	1	< 0.1%
1.64479572 × 10¹²	1	< 0.1%
1.64479554 × 10¹²	1	< 0.1%
1.64479536 × 10¹²	1	< 0.1%
1.64479518 × 10¹²	1	< 0.1%

quote_asset_volume
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	133837
Distinct (%)	79.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9299.26115

Minimum	0
Maximum	1536197.879
Zeros	33414
Zeros (%)	19.9%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	74.929608
median	2844.204384
Q3	10252.18735
95-th percentile	37044.20866
Maximum	1536197.879
Range	1536197.879
Interquartile range (IQR)	10177.25774

Descriptive statistics

Standard deviation	22851.17329
Coefficient of variation (CV)	2.457310631
Kurtosis	605.1538805
Mean	9299.26115
Median Absolute Deviation (MAD)	2844.204384
Skewness	16.25909648
Sum	1559421000
Variance	522176120.6
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	33414	19.9%
26.11583	7	< 0.1%
26.451352	6	< 0.1%
26.513312	6	< 0.1%
22.5335	6	< 0.1%
26.426682	5	< 0.1%
43.339505	5	< 0.1%
20.553035	5	< 0.1%
12.13222	5	< 0.1%
43.081104	5	< 0.1%
Other values (133827)	134229	80.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	33414	19.9%
0.0169769	1	< 0.1%
0.0183274	1	< 0.1%
0.023557	1	< 0.1%
0.0330124	1	< 0.1%
0.036803	1	< 0.1%
0.0550491	1	< 0.1%
0.0653928	1	< 0.1%
0.0736836	1	< 0.1%
0.103698	1	< 0.1%

Value	Count	Frequency (%)
1536197.879	1	< 0.1%
1508185.435	1	< 0.1%
1379494.586	1	< 0.1%
1201363.126	1	< 0.1%
1043585.291	1	< 0.1%
991519.4857	1	< 0.1%
928001.9059	1	< 0.1%
898101.9168	1	< 0.1%
894888.6451	1	< 0.1%
894225.5229	1	< 0.1%

number_of_trades
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	277
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8.899286196

Minimum	0
Maximum	1046
Zeros	33414
Zeros (%)	19.9%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	4
Q3	11
95-th percentile	33
Maximum	1046
Range	1046
Interquartile range (IQR)	10

Descriptive statistics

Standard deviation	16.10302781
Coefficient of variation (CV)	1.809474092
Kurtosis	297.0969966
Mean	8.899286196
Median Absolute Deviation (MAD)	4
Skewness	9.693089299
Sum	1492348
Variance	259.3075045
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	33414	19.9%
1	20326	12.1%
2	14595	8.7%
3	11669	7.0%
4	9635	5.7%
5	7936	4.7%
6	6918	4.1%
7	5976	3.6%
8	5288	3.2%
9	4617	2.8%
Other values (267)	47319	28.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	33414	19.9%
1	20326	12.1%
2	14595	8.7%
3	11669	7.0%
4	9635	5.7%
5	7936	4.7%
6	6918	4.1%
7	5976	3.6%
8	5288	3.2%
9	4617	2.8%

Value	Count	Frequency (%)
1046	1	< 0.1%
914	1	< 0.1%
767	1	< 0.1%
746	1	< 0.1%
696	1	< 0.1%
419	1	< 0.1%
404	1	< 0.1%
390	1	< 0.1%
385	1	< 0.1%
362	1	< 0.1%

taker_buy_base_asset_volume
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED
ZEROS

Distinct	66978
Distinct (%)	39.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.518533806

Minimum	0
Maximum	629.4356
Zeros	70012
Zeros (%)	41.8%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.0629
Q3	1.2877
95-th percentile	6.672394
Maximum	629.4356
Range	629.4356
Interquartile range (IQR)	1.2877

Descriptive statistics

Standard deviation	5.519537423
Coefficient of variation (CV)	3.634780734
Kurtosis	1792.726341
Mean	1.518533806
Median Absolute Deviation (MAD)	0.0629
Skewness	27.29847463
Sum	254647.4896
Variance	30.46529336
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	70012	41.8%
0.5	327	0.2%
1	318	0.2%
0.4	255	0.2%
0.6	243	0.1%
0.65	221	0.1%
0.7	217	0.1%
0.1	204	0.1%
0.3	198	0.1%
0.05	194	0.1%
Other values (66968)	95504	57.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	70012	41.8%
1 × 10^-5	3	< 0.1%
2 × 10^-5	2	< 0.1%
4 × 10^-5	1	< 0.1%
7 × 10^-5	3	< 0.1%
8 × 10^-5	1	< 0.1%
0.0001	10	< 0.1%
0.00013	1	< 0.1%
0.00014	1	< 0.1%
0.00016	1	< 0.1%

Value	Count	Frequency (%)
629.4356	1	< 0.1%
471.47823	1	< 0.1%
391.53518	1	< 0.1%
250.48332	1	< 0.1%
247.31307	1	< 0.1%
237.58096	1	< 0.1%
223.33321	1	< 0.1%
221.95032	1	< 0.1%
219.00216	1	< 0.1%
210.0272	1	< 0.1%

taker_buy_quote_asset_volume
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED
ZEROS

Distinct	96935
Distinct (%)	57.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4376.024455

Minimum	0
Maximum	1507021.742
Zeros	70012
Zeros (%)	41.8%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	176.3552
Q3	3555.792
95-th percentile	20001.84303
Maximum	1507021.742
Range	1507021.742
Interquartile range (IQR)	3555.792

Descriptive statistics

Standard deviation	15685.6432
Coefficient of variation (CV)	3.584450536
Kurtosis	1092.031597
Mean	4376.024455
Median Absolute Deviation (MAD)	176.3552
Skewness	22.69475006
Sum	733828668.9
Variance	246039402.7
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	70012	41.8%
26.516962	9	< 0.1%
43.339505	8	< 0.1%
26.168025	8	< 0.1%
26.27928	8	< 0.1%
22.5335	7	< 0.1%
22.790355	7	< 0.1%
26.408547	7	< 0.1%
22.4270618	7	< 0.1%
26.205921	7	< 0.1%
Other values (96925)	97613	58.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	70012	41.8%
0.019655	1	< 0.1%
0.0330124	1	< 0.1%
0.0350742	1	< 0.1%
0.036803	1	< 0.1%
0.0478676	1	< 0.1%
0.0935672	1	< 0.1%
0.143204	1	< 0.1%
0.170753	1	< 0.1%
0.204722	1	< 0.1%

Value	Count	Frequency (%)
1507021.742	1	< 0.1%
878958.7224	1	< 0.1%
874219.4502	1	< 0.1%
840253.3005	1	< 0.1%
837964.8224	1	< 0.1%
804816.6844	1	< 0.1%
787409.9658	1	< 0.1%
666322.1358	1	< 0.1%
655168.9549	1	< 0.1%
636510.7665	1	< 0.1%

ignore
Categorical

CONSTANT
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

0	167693

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	167693
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	167693	100.0%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
0	167693	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	167693	100.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	167693	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	167693	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	167693	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	167693	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	167693	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	167693	100.0%

return
Real number (ℝ)

Distinct	156249
Distinct (%)	93.4%
Missing	480
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%
Mean	0.003216872948

Minimum	-0.4134126678
Maximum	0.4627397083
Zeros	11
Zeros (%)	< 0.1%
Negative	77397
Negative (%)	46.2%
Memory size	1.3 MiB

Quantile statistics

Minimum	-0.4134126678
5-th percentile	-0.07872063596
Q1	-0.0250697918
median	0.004006037919
Q3	0.03391047352
95-th percentile	0.08089207883
Maximum	0.4627397083
Range	0.8761523761
Interquartile range (IQR)	0.05898026531

Descriptive statistics

Standard deviation	0.05083771007
Coefficient of variation (CV)	15.803456
Kurtosis	3.460966565
Mean	0.003216872948
Median Absolute Deviation (MAD)	0.02953656949
Skewness	-0.1179855097
Sum	537.9029762
Variance	0.002584472765
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-0.002861847029	21	< 0.1%
-0.01980653939	17	< 0.1%
0.03707528242	17	< 0.1%
-0.03068661181	14	< 0.1%
-0.01654311706	13	< 0.1%
-0.01079416803	13	< 0.1%
-0.06019551282	13	< 0.1%
0.005516458844	13	< 0.1%
0.03115241613	13	< 0.1%
0.01563735556	13	< 0.1%
Other values (156239)	167066	99.6%
(Missing)	480	0.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-0.4134126678	1	< 0.1%
-0.4080989784	1	< 0.1%
-0.4038134141	1	< 0.1%
-0.3723921569	1	< 0.1%
-0.3663794359	1	< 0.1%
-0.3648034878	1	< 0.1%
-0.3551193677	1	< 0.1%
-0.3548069743	1	< 0.1%
-0.3539588497	1	< 0.1%
-0.3539423946	1	< 0.1%

Value	Count	Frequency (%)
0.4627397083	1	< 0.1%
0.4322225499	1	< 0.1%
0.4261692947	1	< 0.1%
0.4218145721	1	< 0.1%
0.41724474	1	< 0.1%
0.3881221508	1	< 0.1%
0.3802125549	1	< 0.1%
0.3776508703	1	< 0.1%
0.3774813661	1	< 0.1%
0.3763396057	1	< 0.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	open time	open	high	low	close	volume	close_time	quote_asset_volume	number_of_trades	taker_buy_base_asset_volume	taker_buy_quote_asset_volume	return
0	1614556800000	1422.22	1429.47	1422.22	1423.33	4.21026	1614556979999	6009.598029	8	2.76588	3945.181854	NaN
1	1614556980000	1420.64	1420.64	1413.88	1413.88	11.07088	1614557159999	15683.606427	13	0.14750	209.421975	NaN
2	1614557160000	1415.01	1415.01	1413.51	1413.51	6.42969	1614557339999	9091.381863	9	0.00000	0.000000	NaN
3	1614557340000	1416.68	1416.68	1416.68	1416.68	1.20000	1614557519999	1700.016000	1	0.00000	0.000000	NaN
4	1614557520000	1418.62	1418.62	1418.62	1418.62	0.01992	1614557699999	28.258910	1	0.00000	0.000000	NaN
5	1614557700000	1425.65	1445.86	1425.65	1445.86	3.61788	1614557879999	5213.791001	5	3.47139	5004.947533	NaN
6	1614557880000	1444.44	1444.44	1443.57	1443.57	3.75392	1614558059999	5420.242554	4	0.00000	0.000000	NaN
7	1614558060000	1441.27	1441.27	1441.27	1441.27	0.01790	1614558239999	25.798733	2	0.00895	12.899366	NaN
8	1614558240000	1441.27	1441.27	1441.27	1441.27	0.00000	1614558419999	0.000000	0	0.00000	0.000000	NaN
9	1614558420000	1441.77	1441.77	1441.77	1441.77	1.29914	1614558599999	1873.061078	1	0.00000	0.000000	NaN

Last rows

	open time	open	high	low	close	volume	close_time	quote_asset_volume	number_of_trades	taker_buy_base_asset_volume	taker_buy_quote_asset_volume	return
167683	1644795000000	2879.87	2879.87	2879.87	2879.87	0.1736	1644795179999	499.945432	1	0.0000	0.000000	-0.012881
167684	1644795180000	2879.87	2879.87	2879.87	2879.87	0.0000	1644795359999	0.000000	0	0.0000	0.000000	-0.012881
167685	1644795360000	2879.87	2879.87	2879.87	2879.87	0.0000	1644795539999	0.000000	0	0.0000	0.000000	-0.006729
167686	1644795540000	2877.43	2877.43	2877.43	2877.43	0.2038	1644795719999	586.420234	2	0.2038	586.420234	-0.007571
167687	1644795720000	2878.58	2878.58	2878.58	2878.58	3.4748	1644795899999	10002.489784	5	3.4748	10002.489784	-0.007174
167688	1644795900000	2882.67	2890.48	2882.67	2890.48	3.4838	1644796079999	10042.754305	3	3.4838	10042.754305	-0.003070
167689	1644796080000	2890.48	2890.48	2890.48	2890.48	0.0000	1644796259999	0.000000	0	0.0000	0.000000	-0.003070
167690	1644796260000	2890.48	2890.48	2890.48	2890.48	0.0000	1644796439999	0.000000	0	0.0000	0.000000	-0.003070
167691	1644796440000	2889.42	2889.42	2888.43	2888.43	0.1870	1644796619999	540.150171	3	0.0139	40.162938	-0.003777
167692	1644796620000	2873.25	2873.25	2873.25	2873.25	0.0139	1644796799999	39.938175	1	0.0000	0.000000	-0.009012

Overview

Variables

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows